Quản lý nhân sự công ty bằng c# _ full source code

60.409 lượt xem;
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10 using Telerik.WinControls;
11 using Telerik.Data;
12 using QuanLyNhanSu.Class;
13
14 namespace QuanLyNhanSu
15 {
16     public partial class frmMain : RadRibbonForm
17     {
18         public static frmMain me;
19         public QuanLyNhanSu.Class.sql sql;
20         
21         public frmMain()
22         {
23             readFile c = new readFile();
24             c.readfile();
25             string strServerName = "";
26             string strDatabase = "";
27             if (c.strLine1.Contains("Server:") == true) strServerName = c.strLine1.Substring(7);
28             if (c.strLine2.Contains("Database:") == true) strDatabase = c.strLine2.Substring(9);
29
30             InitializeComponent();
31             sql = new sql(strServerName, strDatabase,
32                 "U0", "123");
33             me = this;
34
35         }
36         private Form KiemTraTonTai(Type formType)
37         {
38             foreach (Form f in this.MdiChildren)
39             {
40                 if (f.GetType() == formType)
41                     return f;
42             }
43             return null;
44         }
45         private string ChuoiTruyCapForm(string ten)
46         {
47             return "Select * from tbl_user_form U inner join " +
48                 "tbl_DMform F on U.IDform=F.ID where U.username='" + sql.GetUser() + "' and F.tenform='" + ten + "' and U.rights=1";
49         }
50         private void btnThoat_Click(object sender, EventArgs e)
51         {
52             DialogResult dr = RadMessageBox.Show("\nBạn có thực sự muốn thoát chương trình ?\n","Thông báo",MessageBoxButtons.YesNo,RadMessageIcon.Question);
53             if (dr == DialogResult.Yes)
54             {
55                 Application.Exit();
56             }
57             else
58             {
59             }
60             
61         }
62
63         private void frmMain_Load(object sender, EventArgs e)
64         {
65             Form1_ obj_ = new Form1_();
66             obj_.ShowDialog();
67             frmConfig obj = new frmConfig();
68             obj.ShowDialog();
69             //DateTime.Parse(layngay());
70
71             //MessageBox.Show(layngay());
72
73
74         }
75         public string layngay()
76         {
77             string sel = "select top 1 percent Start from Appointments order by Start desc";
78             SqlConnection con = frmMain.me.sql.connectSQL();
79             con.Open();
80             SqlCommand sel1 = new SqlCommand(sel, con);
81             object o = sel1.ExecuteScalar();
82             con.Close();
83             return o.ToString();
84         }
85
86         private void btnNhanVien_Click(object sender, EventArgs e)
87         {
88             SqlConnection con = frmMain.me.sql.connectSQL();
89             con.Open();
90             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmNhanvien"), con);
91             if (scmd.ExecuteReader().Read())
92             {
93                 Form frm = KiemTraTonTai(typeof(frmNhanvien));
94                 if (frm != null)
95                     frm.Activate();
96                 else
97                 {
98                     
99                     frmNhanvien f = new frmNhanvien();
100                     f.MdiParent = this;
101                     f.Show();
102                 }
103             }
104             else
105                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo",MessageBoxButtons.OK,RadMessageIcon.Exclamation);
106             con.Close();
107         }
108
109         private void btnTyLeLuongThang_Click(object sender, EventArgs e)
110         {
111             SqlConnection sc = frmMain.me.sql.connectSQL();
112             sc.Open();
113             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmbangtileluong"), sc);
114             if (scmd.ExecuteReader().Read())
115             {
116                 Form frm = KiemTraTonTai(typeof(frmbangtileluong));
117                 if (frm != null)
118                     frm.Activate();
119                 else
120                 {
121                     frmbangtileluong f = new frmbangtileluong();
122                     f.MdiParent = this;
123                     f.Show();
124                 }
125             }
126             else
127                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Exclamation);
128             sc.Close();
129         }
130
131         private void btnChamCong_Click(object sender, EventArgs e)
132         {
133             SqlConnection sc = frmMain.me.sql.connectSQL();
134             sc.Open();
135             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmkiemtrabangluong"), sc);
136             if (scmd.ExecuteReader().Read())
137             {
138                 Form frm = KiemTraTonTai(typeof(frmkiemtrabangluong));
139                 if (frm != null)
140                     frm.Activate();
141                 else
142                 {
143                     frmkiemtrabangluong f = new frmkiemtrabangluong();
144                     f.MdiParent = this;
145                     f.Show();
146                 }
147             }
148             else
149                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo",MessageBoxButtons.OK,RadMessageIcon.Exclamation);
150             sc.Close();
151         }
152
153         private void btnChucVu_Click(object sender, EventArgs e)
154         {
155             SqlConnection sc = frmMain.me.sql.connectSQL();
156             sc.Open();
157             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMChucVu"), sc);
158             if (scmd.ExecuteReader().Read())
159             {
160                 Form frm = KiemTraTonTai(typeof(frmDMChucVu));
161                 if (frm != null)
162                     frm.Activate();
163                 else
164                 {
165                     frmDMChucVu f = new frmDMChucVu();
166                     f.MdiParent = this;
167                     f.Show();
168                 }
169             }
170             else
171                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo",MessageBoxButtons.OK,RadMessageIcon.Exclamation);
172             sc.Close();
173         }
174
175         private void btnPhanQuyen_Click(object sender, EventArgs e)
176         {
177             Form frm = KiemTraTonTai(typeof(frmPhanQuyen));
178             if (frm != null)
179                 frm.Activate();
180             else
181             {
182                 frmPhanQuyen f = new frmPhanQuyen();
183                 f.MdiParent = this;
184                 f.Show();
185             }
186         }
187
188         private void btnBCLuongThang_Click(object sender, EventArgs e)
189         {
190             SqlConnection sc = frmMain.me.sql.connectSQL();
191             sc.Open();
192             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmchonbcluong"), sc);
193             if (scmd.ExecuteReader().Read())
194             {
195                 Form frm = KiemTraTonTai(typeof(frmchonbcluong));
196                 if (frm != null)
197                     frm.Activate();
198                 else
199                 {
200                     frmchonbcluong f = new frmchonbcluong();
201                     f.MdiParent = this;
202                     f.Show();
203                 }
204             }
205             else
206                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo",MessageBoxButtons.OK,RadMessageIcon.Exclamation);
207             sc.Close();
208         }
209
210         private void btnBCNhanSu_Click(object sender, EventArgs e)
211         {
212             SqlConnection sc = frmMain.me.sql.connectSQL();
213             sc.Open();
214             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmchonbcnv"), sc);
215             if (scmd.ExecuteReader().Read())
216             {
217                 Form frm = KiemTraTonTai(typeof(frmchonbcnv));
218                 if (frm != null)
219                     frm.Activate();
220                 else
221                 {
222                     frmchonbcnv f = new frmchonbcnv();
223                     f.MdiParent = this;
224                     f.Show();
225                 }
226             }
227             else
228                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo",MessageBoxButtons.OK,RadMessageIcon.Error);
229             sc.Close();
230         }
231
232         private void btnHDHetHan_Click(object sender, EventArgs e)
233         {
234             SqlConnection sc = frmMain.me.sql.connectSQL();
235             sc.Open();
236             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmKiemTraHDHetHan"), sc);
237             if (scmd.ExecuteReader().Read())
238             {
239                 Form frm = KiemTraTonTai(typeof(frmKiemTraHDHetHan));
240                 if (frm != null)
241                     frm.Activate();
242                 else
243                 {
244                     frmKiemTraHDHetHan f = new frmKiemTraHDHetHan();
245                     f.MdiParent = this;
246                     f.Show();
247                 }
248             }
249             else
250                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
251             sc.Close();
252         }
253
254         private void btnDangXuat_Click(object sender, EventArgs e)
255         {
256
257             //Application.Restart();
258             frmDangNhap obj = new frmDangNhap();
259             obj.ShowDialog();
260             
261             
262         }
263
264         private void btnDoiMatKau_Click(object sender, EventArgs e)
265         {
266             Form frm = KiemTraTonTai(typeof(frmDoiMatKhau));
267             if (frm != null)
268                 frm.Activate();
269             else
270             {
271                 frmDoiMatKhau f = new frmDoiMatKhau();
272                 f.MdiParent = this;
273                 f.Show();
274             }
275         }
276
277         private void btnTonGiao_Click(object sender, EventArgs e)
278         {
279             SqlConnection sc = frmMain.me.sql.connectSQL();
280             sc.Open();
281             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMTonGiao"), sc);
282             if (scmd.ExecuteReader().Read())
283             {
284                 Form frm = KiemTraTonTai(typeof(frmDMTonGiao));
285                 if (frm != null)
286                     frm.Activate();
287                 else
288                 {
289                     frmDMTonGiao f = new frmDMTonGiao();
290                     f.MdiParent = this;
291                     f.Show();
292                 }
293             }
294             else
295                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
296             sc.Close();
297         }
298
299         private void btnDanToc_Click(object sender, EventArgs e)
300         {
301             SqlConnection sc = frmMain.me.sql.connectSQL();
302             sc.Open();
303             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMDanToc"), sc);
304             if (scmd.ExecuteReader().Read())
305             {
306                 Form frm = KiemTraTonTai(typeof(frmDMDanToc));
307                 if (frm != null)
308                     frm.Activate();
309                 else
310                 {
311                     frmDMDanToc f = new frmDMDanToc();
312                     f.MdiParent = this;
313                     f.Show();
314                 }
315             }
316             else
317                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
318             sc.Close();
319         }
320
321         private void btnTrinhDo_Click(object sender, EventArgs e)
322         {
323             SqlConnection sc = frmMain.me.sql.connectSQL();
324             sc.Open();
325             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMTrinhDo"), sc);
326             if (scmd.ExecuteReader().Read())
327             {
328                 Form frm = KiemTraTonTai(typeof(frmDMTrinhDo));
329                 if (frm != null)
330                     frm.Activate();
331                 else
332                 {
333                     frmDMTrinhDo f = new frmDMTrinhDo();
334                     f.MdiParent = this;
335                     f.Show();
336                 }
337             }
338             else
339                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
340             sc.Close();
341         }
342
343         private void btnChuyenMon_Click(object sender, EventArgs e)
344         {
345             SqlConnection sc = frmMain.me.sql.connectSQL();
346             sc.Open();
347             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMChuyenMon"), sc);
348             if (scmd.ExecuteReader().Read())
349             {
350                 Form frm = KiemTraTonTai(typeof(frmDMChuyenMon));
351                 if (frm != null)
352                     frm.Activate();
353                 else
354                 {
355                     frmDMChuyenMon f = new frmDMChuyenMon();
356                     f.MdiParent = this;
357                     f.Show();
358                 }
359             }
360             else
361                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
362             sc.Close();
363         }
364
365         private void btnNgoaiNgu_Click(object sender, EventArgs e)
366         {
367             SqlConnection sc = frmMain.me.sql.connectSQL();
368             sc.Open();
369             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMNgoaiNgu"), sc);
370             if (scmd.ExecuteReader().Read())
371             {
372                 Form frm = KiemTraTonTai(typeof(frmDMNgoaiNgu));
373                 if (frm != null)
374                     frm.Activate();
375                 else
376                 {
377                     frmDMNgoaiNgu f = new frmDMNgoaiNgu();
378                     f.MdiParent = this;
379                     f.Show();
380                 }
381             }
382             else
383                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
384             sc.Close();
385         }
386
387         private void btnPhongBan_Click(object sender, EventArgs e)
388         {
389             SqlConnection sc = frmMain.me.sql.connectSQL();
390             sc.Open();
391             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMPhongBan"), sc);
392             if (scmd.ExecuteReader().Read())
393             {
394                 Form frm = KiemTraTonTai(typeof(frmDMPhongBan));
395                 if (frm != null)
396                     frm.Activate();
397                 else
398                 {
399                     frmDMPhongBan f = new frmDMPhongBan();
400                     f.MdiParent = this;
401                     f.Show();
402                 }
403             }
404             else
405                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
406             sc.Close();
407         }
408
409         private void btnTo_Click(object sender, EventArgs e)
410         {
411             SqlConnection sc = frmMain.me.sql.connectSQL();
412             sc.Open();
413             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMTo"), sc);
414             if (scmd.ExecuteReader().Read())
415             {
416                 Form frm = KiemTraTonTai(typeof(frmDMTo));
417                 if (frm != null)
418                     frm.Activate();
419                 else
420                 {
421                     frmDMTo f = new frmDMTo();
422                     f.MdiParent = this;
423                     f.Show();
424                 }
425             }
426             else
427                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
428             sc.Close();
429         }
430
431         private void btnLoaiHopDong_Click(object sender, EventArgs e)
432         {
433             SqlConnection sc = frmMain.me.sql.connectSQL();
434             sc.Open();
435             SqlCommand scmd = new SqlCommand(ChuoiTruyCapForm("frmDMLoaiHD"), sc);
436             if (scmd.ExecuteReader().Read())
437             {
438                 Form frm = KiemTraTonTai(typeof(frmDMLoaiHD));
439                 if (frm != null)
440                     frm.Activate();
441                 else
442                 {
443                     frmDMLoaiHD f = new frmDMLoaiHD();
444                     f.MdiParent = this;
445                     f.Show();
446                 }
447             }
448             else
449                 RadMessageBox.Show("\nBạn không có quyền truy cập !\n", "Thông Báo", MessageBoxButtons.OK, RadMessageIcon.Error);
450             sc.Close();
451         }
452
453         private void btnTaoNguoiDung_Click(object sender, EventArgs e)
454         {
455             Form frm = KiemTraTonTai(typeof(frmUser));
456             if (frm != null)
457                 frm.Activate();
458             else
459             {
460                 frmUser f = new frmUser();
461                 f.MdiParent = this;
462                 f.Show();
463             }
464         }
465
466         private void btnThongTin_Click(object sender, EventArgs e)
467         {
468             Form frm = KiemTraTonTai(typeof(frmThongTin));
469             if (frm != null)
470                 frm.Activate();
471             else
472             {
473                 frmThongTin f = new frmThongTin();
474                 f.MdiParent = this;
475                 f.Show();
476             }
477         }
478
479         private void btnDMHieuQua_Click(object sender, EventArgs e)
480         {
481             Form frm = KiemTraTonTai(typeof(frmDMHieuQua));
482             if (frm != null)
483                 frm.Activate();
484             else
485             {
486                 frmDMHieuQua f = new frmDMHieuQua();
487                 f.MdiParent = this;
488                 f.Show();
489             }
490         }
491
492         private void radImageButtonElement1_Click(object sender, EventArgs e)
493         {
494             Form frm = KiemTraTonTai(typeof(frmLichLamViec));
495             if (frm != null)
496                 frm.Activate();
497             else
498             {
499                 frmLichLamViec f = new frmLichLamViec();
500                 f.MdiParent = this;
501                 f.Show();
502             }
503         }
504
505         private void radMenuItem1_Click(object sender, EventArgs e)
506         {
507             DialogResult dr = RadMessageBox.Show("\nBạn có thực sự muốn thoát chương trình ?\n", "Thông báo", MessageBoxButtons.YesNo, RadMessageIcon.Question);
508             if (dr == DialogResult.Yes)
509             {
510                 Application.Exit();
511             }
512             else
513             {
514             }
515         }
516
517
518         
519     }
520 }



Quản lý nhân sự công ty bằng c# _ full source code 60.409 lượt xem

Gõ tìm kiếm nhanh...



Dự án liên quan!

Cách tạo đồng hồ bấm giờ trong C#

93 lượt xem

Hệ thống quản lý hàng tồn kho sử dụng cơ sở dữ liệu VB.NET và MySQL với mã nguồn

99 lượt xem

Đếm nguyên âm và phụ âm

135 lượt xem

Phần mềm quản lý nhân viên hiện đại sử dụng C#.net và Bunifu Framework với Full Source Code (2020)

211 lượt xem

Hệ thống quản lý đại học bằng C# với mã nguồn đầy đủ

168 lượt xem

Hệ thống quản lý bệnh viện bằng C# với mã nguồn đầy đủ

185 lượt xem